How to: Format lines in Excel.
Solution:
Select the line, then select 'Object...' from the 'Format' menu. From the 'Patterns' tab, update the line selections.
1) Select the line to be formatted.
2) Select the 'Format' menu and select 'Object...'. (The Format Object dialog box appears.)
3) Click the 'Patterns' tab.
4) In the 'Line' group, select the desired format options from the displayed radio buttons, check boxes and drop-down list boxes.
5) Click 'OK'.
